package com.mhc.suzuki.dal.query;


import com.subaru.common.query.BaseCriteria;
import com.subaru.common.query.BaseQuery;
import org.apache.commons.lang.builder.ReflectionToStringBuilder;
import org.apache.commons.lang.builder.ToStringStyle;

import java.io.Serializable;

import java.time.LocalDate;
import java.time.LocalDateTime;
import java.util.List;

public class InsuranceInfoQuery extends BaseQuery implements Serializable {
    private static final long serialVersionUID = 1L;

    public InsuranceInfoQuery() {
        super();
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        super.oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    /**
     * This class corresponds to the database table pcl_insurance_info
     */
         protected abstract static class GeneratedCriteria extends BaseCriteria {

        protected GeneratedCriteria() {
            super();
        }

        public Criteria andInsIdIsNull() {
            addCriterion("ins_id is null");
            return (Criteria) this;
        }

        public Criteria andInsIdIsNotNull() {
            addCriterion("ins_id is not null");
            return (Criteria) this;
        }

        public Criteria andInsIdEqualTo(Long value) {
            addCriterion("ins_id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andInsIdNotEqualTo(Long value) {
            addCriterion("ins_id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria anInsIdGreaterThan(Long value) {
            addCriterion("ins_id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andInsIdGreaterThanOrEqualTo(Long value) {
            addCriterion("ins_id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andInsIdLessThan(Long value) {
            addCriterion("ins_id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andInsIdLessThanOrEqualTo(Long value) {
            addCriterion("ins_id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andInsIdIn(List<Long> values) {
            addCriterion("ins_id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andInsIdNotIn(List<Long> values) {
            addCriterion("ins_id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andInsIdBetween(Long value1, Long value2) {
            addCriterion("ins_id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andInsIdNotBetween(Long value1, Long value2) {
            addCriterion("ins_id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andGmtCreateIsNull() {
            addCriterion("gmt_create is null");
            return (Criteria) this;
        }

        public Criteria andGmtCreateIsNotNull() {
            addCriterion("gmt_create is not null");
            return (Criteria) this;
        }

        public Criteria andGmtCreateEqualTo(LocalDate value) {
            addCriterion("gmt_create =", value, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateNotEqualTo(LocalDate value) {
            addCriterion("gmt_create <>", value, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateGreaterThan(LocalDate value) {
            addCriterion("gmt_create >", value, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateGreaterThanOrEqualTo(LocalDate value) {
            addCriterion("gmt_create >=", value, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateLessThan(LocalDate value) {
            addCriterion("gmt_create <", value, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateLessThanOrEqualTo(LocalDate value) {
            addCriterion("gmt_create <=", value, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateIn(List<LocalDate> values) {
            addCriterion("gmt_create in", values, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateNotIn(List<LocalDate> values) {
            addCriterion("gmt_create not in", values, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateBetween(LocalDate value1, LocalDate value2) {
            addCriterion("gmt_create between", value1, value2, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateNotBetween(LocalDate value1, LocalDate value2) {
            addCriterion("gmt_create not between", value1, value2, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedIsNull() {
            addCriterion("gmt_modified is null");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedIsNotNull() {
            addCriterion("gmt_modified is not null");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedEqualTo(LocalDate value) {
            addCriterion("gmt_modified =", value, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedNotEqualTo(LocalDate value) {
            addCriterion("gmt_modified <>", value, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedGreaterThan(LocalDate value) {
            addCriterion("gmt_modified >", value, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedGreaterThanOrEqualTo(LocalDate value) {
            addCriterion("gmt_modified >=", value, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedLessThan(LocalDate value) {
            addCriterion("gmt_modified <", value, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedLessThanOrEqualTo(LocalDate value) {
            addCriterion("gmt_modified <=", value, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedIn(List<LocalDate> values) {
            addCriterion("gmt_modified in", values, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedNotIn(List<LocalDate> values) {
            addCriterion("gmt_modified not in", values, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedBetween(LocalDate value1, LocalDate value2) {
            addCriterion("gmt_modified between", value1, value2, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedNotBetween(LocalDate value1, LocalDate value2) {
            addCriterion("gmt_modified not between", value1, value2, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andOrderNoIsNull() {
            addCriterion("order_no is null");
            return (Criteria) this;
        }

        public Criteria andOrderNoIsNotNull() {
            addCriterion("order_no is not null");
            return (Criteria) this;
        }

        public Criteria andOrderNoEqualTo(String value) {
            addCriterion("order_no =", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoNotEqualTo(String value) {
            addCriterion("order_no <>", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoGreaterThan(String value) {
            addCriterion("order_no >", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoGreaterThanOrEqualTo(String value) {
            addCriterion("order_no >=", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoLessThan(String value) {
            addCriterion("order_no <", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoLessThanOrEqualTo(String value) {
            addCriterion("order_no <=", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoLike(String value) {
            addCriterion("order_no like", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoNotLike(String value) {
            addCriterion("order_no not like", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoIn(List<String> values) {
            addCriterion("order_no in", values, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoNotIn(List<String> values) {
            addCriterion("order_no not in", values, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoBetween(String value1, String value2) {
            addCriterion("order_no between", value1, value2, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoNotBetween(String value1, String value2) {
            addCriterion("order_no not between", value1, value2, "orderNo");
            return (Criteria) this;
        }

        public Criteria andInsTypeIsNull() {
            addCriterion("ins_type is null");
            return (Criteria) this;
        }

        public Criteria andInsTypeIsNotNull() {
            addCriterion("ins_type is not null");
            return (Criteria) this;
        }

        public Criteria andInsTypeEqualTo(Integer value) {
            addCriterion("ins_type =", value, "insType");
            return (Criteria) this;
        }

        public Criteria andInsTypeNotEqualTo(Integer value) {
            addCriterion("ins_type <>", value, "insType");
            return (Criteria) this;
        }

        public Criteria andInsTypeGreaterThan(Integer value) {
            addCriterion("ins_type >", value, "insType");
            return (Criteria) this;
        }

        public Criteria andInsTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("ins_type >=", value, "insType");
            return (Criteria) this;
        }

        public Criteria andInsTypeLessThan(Integer value) {
            addCriterion("ins_type <", value, "insType");
            return (Criteria) this;
        }

        public Criteria andInsTypeLessThanOrEqualTo(Integer value) {
            addCriterion("ins_type <=", value, "insType");
            return (Criteria) this;
        }

        public Criteria andInsTypeLike(Integer value) {
            addCriterion("ins_type like", value, "insType");
            return (Criteria) this;
        }

        public Criteria andInsTypeNotLike(Integer value) {
            addCriterion("ins_type not like", value, "insType");
            return (Criteria) this;
        }

        public Criteria andInsTypeIn(List<Integer> values) {
            addCriterion("ins_type in", values, "insType");
            return (Criteria) this;
        }

        public Criteria andInsTypeNotIn(List<Integer> values) {
            addCriterion("ins_type not in", values, "insType");
            return (Criteria) this;
        }

        public Criteria andInsTypeBetween(Integer value1, Integer value2) {
            addCriterion("ins_type between", value1, value2, "insType");
            return (Criteria) this;
        }

        public Criteria andInsTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("ins_type not between", value1, value2, "insType");
            return (Criteria) this;
        }

        public Criteria andInsCompanyIdIsNull() {
            addCriterion("ins_company_id is null");
            return (Criteria) this;
        }

        public Criteria andInsCompanyIdIsNotNull() {
            addCriterion("ins_company_id is not null");
            return (Criteria) this;
        }

        public Criteria andInsCompanyIdEqualTo(Long value) {
            addCriterion("ins_company_id =", value, "insCompanyId");
            return (Criteria) this;
        }

        public Criteria andInsCompanyIdNotEqualTo(Long value) {
            addCriterion("ins_company_id <>", value, "insCompanyId");
            return (Criteria) this;
        }

        public Criteria andInsCompanyIdGreaterThan(Long value) {
            addCriterion("ins_company_id >", value, "insCompanyId");
            return (Criteria) this;
        }

        public Criteria andInsCompanyIdGreaterThanOrEqualTo(Long value) {
            addCriterion("ins_company_id >=", value, "insCompanyId");
            return (Criteria) this;
        }

        public Criteria andInsCompanyIdLessThan(Long value) {
            addCriterion("ins_company_id <", value, "insCompanyId");
            return (Criteria) this;
        }

        public Criteria andInsCompanyIdLessThanOrEqualTo(Long value) {
            addCriterion("ins_company_id <=", value, "insCompanyId");
            return (Criteria) this;
        }

        public Criteria andInsCompanyIdLike(Long value) {
            addCriterion("ins_company_id like", value, "insCompanyId");
            return (Criteria) this;
        }

        public Criteria andInsCompanyIdNotLike(Long value) {
            addCriterion("ins_company_id not like", value, "insCompanyId");
            return (Criteria) this;
        }

        public Criteria andInsCompanyIdIn(List<Long> values) {
            addCriterion("ins_company_id in", values, "insCompanyId");
            return (Criteria) this;
        }

        public Criteria andInsCompanyIdNotIn(List<Long> values) {
            addCriterion("ins_company_id not in", values, "insCompanyId");
            return (Criteria) this;
        }

        public Criteria andInsCompanyIdBetween(Long value1, Long value2) {
            addCriterion("ins_company_id between", value1, value2, "insCompanyId");
            return (Criteria) this;
        }

        public Criteria andInsCompanyIdNotBetween(Long value1, Long value2) {
            addCriterion("ins_company_id not between", value1, value2, "insCompanyId");
            return (Criteria) this;
        }

        public Criteria andInsCompanyNameIsNull() {
            addCriterion("ins_company_name is null");
            return (Criteria) this;
        }

        public Criteria andInsCompanyNameIsNotNull() {
            addCriterion("ins_company_name is not null");
            return (Criteria) this;
        }

        public Criteria andInsCompanyNameEqualTo(String value) {
            addCriterion("ins_company_name =", value, "insCompanyName");
            return (Criteria) this;
        }

        public Criteria andInsCompanyNameNotEqualTo(String value) {
            addCriterion("ins_company_name <>", value, "insCompanyName");
            return (Criteria) this;
        }

        public Criteria andInsCompanyNameGreaterThan(String value) {
            addCriterion("ins_company_name >", value, "insCompanyName");
            return (Criteria) this;
        }

        public Criteria andInsCompanyNameGreaterThanOrEqualTo(String value) {
            addCriterion("ins_company_name >=", value, "insCompanyName");
            return (Criteria) this;
        }

        public Criteria andInsCompanyNameLessThan(String value) {
            addCriterion("ins_company_name <", value, "insCompanyName");
            return (Criteria) this;
        }

        public Criteria andInsCompanyNameLessThanOrEqualTo(String value) {
            addCriterion("ins_company_name <=", value, "insCompanyName");
            return (Criteria) this;
        }

        public Criteria andInsCompanyNameLike(String value) {
            addCriterion("ins_company_name like", value, "insCompanyName");
            return (Criteria) this;
        }

        public Criteria andInsCompanyNameNotLike(String value) {
            addCriterion("ins_company_name not like", value, "insCompanyName");
            return (Criteria) this;
        }

        public Criteria andInsCompanyNameIn(List<String> values) {
            addCriterion("ins_company_name in", values, "insCompanyName");
            return (Criteria) this;
        }

        public Criteria andInsCompanyNameNotIn(List<String> values) {
            addCriterion("ins_company_name not in", values, "insCompanyName");
            return (Criteria) this;
        }

        public Criteria andInsCompanyNameBetween(String value1, String value2) {
            addCriterion("ins_company_name between", value1, value2, "insCompanyName");
            return (Criteria) this;
        }

        public Criteria andInsCompanyNameNotBetween(String value1, String value2) {
            addCriterion("ins_company_name not between", value1, value2, "insCompanyName");
            return (Criteria) this;
        }

        public Criteria andInsNoIsNull() {
            addCriterion("ins_no is null");
            return (Criteria) this;
        }

        public Criteria andInsNoIsNotNull() {
            addCriterion("ins_no is not null");
            return (Criteria) this;
        }

        public Criteria andInsNoEqualTo(String value) {
            addCriterion("ins_no =", value, "insNo");
            return (Criteria) this;
        }

        public Criteria andInsNoNotEqualTo(String value) {
            addCriterion("ins_no <>", value, "insNo");
            return (Criteria) this;
        }

        public Criteria andInsNoGreaterThan(String value) {
            addCriterion("ins_no >", value, "insNo");
            return (Criteria) this;
        }

        public Criteria andInsNoGreaterThanOrEqualTo(String value) {
            addCriterion("ins_no >=", value, "insNo");
            return (Criteria) this;
        }

        public Criteria andInsNoLessThan(String value) {
            addCriterion("ins_no <", value, "insNo");
            return (Criteria) this;
        }

        public Criteria andInsNoLessThanOrEqualTo(String value) {
            addCriterion("ins_no <=", value, "insNo");
            return (Criteria) this;
        }

        public Criteria andInsNoLike(String value) {
            addCriterion("ins_no like", value, "insNo");
            return (Criteria) this;
        }

        public Criteria andInsNoNotLike(String value) {
            addCriterion("ins_no not like", value, "insNo");
            return (Criteria) this;
        }

        public Criteria andInsNoIn(List<String> values) {
            addCriterion("ins_no in", values, "insNo");
            return (Criteria) this;
        }

        public Criteria andInsNoNotIn(List<String> values) {
            addCriterion("ins_no not in", values, "insNo");
            return (Criteria) this;
        }

        public Criteria andInsNoBetween(String value1, String value2) {
            addCriterion("ins_no between", value1, value2, "insNo");
            return (Criteria) this;
        }

        public Criteria andInsNoNotBetween(String value1, String value2) {
            addCriterion("ins_no not between", value1, value2, "insNo");
            return (Criteria) this;
        }

        public Criteria andEffectiveDateIsNull() {
            addCriterion("effective_date is null");
            return (Criteria) this;
        }

        public Criteria andEffectiveDateIsNotNull() {
            addCriterion("effective_date is not null");
            return (Criteria) this;
        }

        public Criteria andEffectiveDateEqualTo(LocalDateTime value) {
            addCriterion("effective_date =", value, "effectiveDate");
            return (Criteria) this;
        }

        public Criteria andEffectiveDateNotEqualTo(LocalDateTime value) {
            addCriterion("effective_date <>", value, "effectiveDate");
            return (Criteria) this;
        }

        public Criteria andEffectiveDateGreaterThan(LocalDateTime value) {
            addCriterion("effective_date >", value, "effectiveDate");
            return (Criteria) this;
        }

        public Criteria andEffectiveDateGreaterThanOrEqualTo(LocalDateTime value) {
            addCriterion("effective_date >=", value, "effectiveDate");
            return (Criteria) this;
        }

        public Criteria andEffectiveDateLessThan(LocalDateTime value) {
            addCriterion("effective_date <", value, "effectiveDate");
            return (Criteria) this;
        }

        public Criteria andEffectiveDateLessThanOrEqualTo(LocalDateTime value) {
            addCriterion("effective_date <=", value, "effectiveDate");
            return (Criteria) this;
        }

        public Criteria andEffectiveDateLike(LocalDateTime value) {
            addCriterion("effective_date like", value, "effectiveDate");
            return (Criteria) this;
        }

        public Criteria andEffectiveDateNotLike(LocalDateTime value) {
            addCriterion("effective_date not like", value, "effectiveDate");
            return (Criteria) this;
        }

        public Criteria andEffectiveDateIn(List<LocalDateTime> values) {
            addCriterion("effective_date in", values, "effectiveDate");
            return (Criteria) this;
        }

        public Criteria andEffectiveDateNotIn(List<LocalDateTime> values) {
            addCriterion("effective_date not in", values, "effectiveDate");
            return (Criteria) this;
        }

        public Criteria andEffectiveDateBetween(LocalDateTime value1, LocalDateTime value2) {
            addCriterion("effective_date between", value1, value2, "effectiveDate");
            return (Criteria) this;
        }

        public Criteria andEffectiveDateNotBetween(LocalDateTime value1, LocalDateTime value2) {
            addCriterion("effective_date not between", value1, value2, "effectiveDate");
            return (Criteria) this;
        }

        public Criteria andExpiryDateIsNull() {
            addCriterion("expiry_date is null");
            return (Criteria) this;
        }

        public Criteria andExpiryDateIsNotNull() {
            addCriterion("expiry_date is not null");
            return (Criteria) this;
        }

        public Criteria andExpiryDateEqualTo(LocalDateTime value) {
            addCriterion("expiry_date =", value, "expiryDate");
            return (Criteria) this;
        }

        public Criteria andExpiryDateNotEqualTo(LocalDateTime value) {
            addCriterion("expiry_date <>", value, "expiryDate");
            return (Criteria) this;
        }

        public Criteria andExpiryDateGreaterThan(LocalDateTime value) {
            addCriterion("expiry_date >", value, "expiryDate");
            return (Criteria) this;
        }

        public Criteria andExpiryDateGreaterThanOrEqualTo(LocalDateTime value) {
            addCriterion("expiry_date >=", value, "expiryDate");
            return (Criteria) this;
        }

        public Criteria andExpiryDateLessThan(LocalDateTime value) {
            addCriterion("expiry_date <", value, "expiryDate");
            return (Criteria) this;
        }

        public Criteria andExpiryDateLessThanOrEqualTo(LocalDateTime value) {
            addCriterion("expiry_date <=", value, "expiryDate");
            return (Criteria) this;
        }

        public Criteria andExpiryDateLike(LocalDateTime value) {
            addCriterion("expiry_date like", value, "expiryDate");
            return (Criteria) this;
        }

        public Criteria andExpiryDateNotLike(LocalDateTime value) {
            addCriterion("expiry_date not like", value, "expiryDate");
            return (Criteria) this;
        }

        public Criteria andExpiryDateIn(List<LocalDateTime> values) {
            addCriterion("expiry_date in", values, "expiryDate");
            return (Criteria) this;
        }

        public Criteria andExpiryDateNotIn(List<LocalDateTime> values) {
            addCriterion("expiry_date not in", values, "expiryDate");
            return (Criteria) this;
        }

        public Criteria andExpiryDateBetween(LocalDateTime value1, LocalDateTime value2) {
            addCriterion("expiry_date between", value1, value2, "expiryDate");
            return (Criteria) this;
        }

        public Criteria andExpiryDateNotBetween(LocalDateTime value1, LocalDateTime value2) {
            addCriterion("expiry_date not between", value1, value2, "expiryDate");
            return (Criteria) this;
        }

        public Criteria andVehicleVesselTaxIsNull() {
            addCriterion("vehicle_vessel_tax is null");
            return (Criteria) this;
        }

        public Criteria andVehicleVesselTaxIsNotNull() {
            addCriterion("vehicle_vessel_tax is not null");
            return (Criteria) this;
        }

        public Criteria andVehicleVesselTaxEqualTo(java.math.BigDecimal value) {
            addCriterion("vehicle_vessel_tax =", value, "vehicleVesselTax");
            return (Criteria) this;
        }

        public Criteria andVehicleVesselTaxNotEqualTo(java.math.BigDecimal value) {
            addCriterion("vehicle_vessel_tax <>", value, "vehicleVesselTax");
            return (Criteria) this;
        }

        public Criteria andVehicleVesselTaxGreaterThan(java.math.BigDecimal value) {
            addCriterion("vehicle_vessel_tax >", value, "vehicleVesselTax");
            return (Criteria) this;
        }

        public Criteria andVehicleVesselTaxGreaterThanOrEqualTo(java.math.BigDecimal value) {
            addCriterion("vehicle_vessel_tax >=", value, "vehicleVesselTax");
            return (Criteria) this;
        }

        public Criteria andVehicleVesselTaxLessThan(java.math.BigDecimal value) {
            addCriterion("vehicle_vessel_tax <", value, "vehicleVesselTax");
            return (Criteria) this;
        }

        public Criteria andVehicleVesselTaxLessThanOrEqualTo(java.math.BigDecimal value) {
            addCriterion("vehicle_vessel_tax <=", value, "vehicleVesselTax");
            return (Criteria) this;
        }

        public Criteria andVehicleVesselTaxLike(java.math.BigDecimal value) {
            addCriterion("vehicle_vessel_tax like", value, "vehicleVesselTax");
            return (Criteria) this;
        }

        public Criteria andVehicleVesselTaxNotLike(java.math.BigDecimal value) {
            addCriterion("vehicle_vessel_tax not like", value, "vehicleVesselTax");
            return (Criteria) this;
        }

        public Criteria andVehicleVesselTaxIn(List<java.math.BigDecimal> values) {
            addCriterion("vehicle_vessel_tax in", values, "vehicleVesselTax");
            return (Criteria) this;
        }

        public Criteria andVehicleVesselTaxNotIn(List<java.math.BigDecimal> values) {
            addCriterion("vehicle_vessel_tax not in", values, "vehicleVesselTax");
            return (Criteria) this;
        }

        public Criteria andVehicleVesselTaxBetween(java.math.BigDecimal value1, java.math.BigDecimal value2) {
            addCriterion("vehicle_vessel_tax between", value1, value2, "vehicleVesselTax");
            return (Criteria) this;
        }

        public Criteria andVehicleVesselTaxNotBetween(java.math.BigDecimal value1, java.math.BigDecimal value2) {
            addCriterion("vehicle_vessel_tax not between", value1, value2, "vehicleVesselTax");
            return (Criteria) this;
        }

        public Criteria andPremiumIsNull() {
            addCriterion("premium is null");
            return (Criteria) this;
        }

        public Criteria andPremiumIsNotNull() {
            addCriterion("premium is not null");
            return (Criteria) this;
        }

        public Criteria andPremiumEqualTo(java.math.BigDecimal value) {
            addCriterion("premium =", value, "premium");
            return (Criteria) this;
        }

        public Criteria andPremiumNotEqualTo(java.math.BigDecimal value) {
            addCriterion("premium <>", value, "premium");
            return (Criteria) this;
        }

        public Criteria andPremiumGreaterThan(java.math.BigDecimal value) {
            addCriterion("premium >", value, "premium");
            return (Criteria) this;
        }

        public Criteria andPremiumGreaterThanOrEqualTo(java.math.BigDecimal value) {
            addCriterion("premium >=", value, "premium");
            return (Criteria) this;
        }

        public Criteria andPremiumLessThan(java.math.BigDecimal value) {
            addCriterion("premium <", value, "premium");
            return (Criteria) this;
        }

        public Criteria andPremiumLessThanOrEqualTo(java.math.BigDecimal value) {
            addCriterion("premium <=", value, "premium");
            return (Criteria) this;
        }

        public Criteria andPremiumLike(java.math.BigDecimal value) {
            addCriterion("premium like", value, "premium");
            return (Criteria) this;
        }

        public Criteria andPremiumNotLike(java.math.BigDecimal value) {
            addCriterion("premium not like", value, "premium");
            return (Criteria) this;
        }

        public Criteria andPremiumIn(List<java.math.BigDecimal> values) {
            addCriterion("premium in", values, "premium");
            return (Criteria) this;
        }

        public Criteria andPremiumNotIn(List<java.math.BigDecimal> values) {
            addCriterion("premium not in", values, "premium");
            return (Criteria) this;
        }

        public Criteria andPremiumBetween(java.math.BigDecimal value1, java.math.BigDecimal value2) {
            addCriterion("premium between", value1, value2, "premium");
            return (Criteria) this;
        }

        public Criteria andPremiumNotBetween(java.math.BigDecimal value1, java.math.BigDecimal value2) {
            addCriterion("premium not between", value1, value2, "premium");
            return (Criteria) this;
        }

        public Criteria andStaffIdIsNull() {
            addCriterion("staff_id is null");
            return (Criteria) this;
        }

        public Criteria andStaffIdIsNotNull() {
            addCriterion("staff_id is not null");
            return (Criteria) this;
        }

        public Criteria andStaffIdEqualTo(Long value) {
            addCriterion("staff_id =", value, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdNotEqualTo(Long value) {
            addCriterion("staff_id <>", value, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdGreaterThan(Long value) {
            addCriterion("staff_id >", value, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdGreaterThanOrEqualTo(Long value) {
            addCriterion("staff_id >=", value, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdLessThan(Long value) {
            addCriterion("staff_id <", value, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdLessThanOrEqualTo(Long value) {
            addCriterion("staff_id <=", value, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdLike(Long value) {
            addCriterion("staff_id like", value, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdNotLike(Long value) {
            addCriterion("staff_id not like", value, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdIn(List<Long> values) {
            addCriterion("staff_id in", values, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdNotIn(List<Long> values) {
            addCriterion("staff_id not in", values, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdBetween(Long value1, Long value2) {
            addCriterion("staff_id between", value1, value2, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdNotBetween(Long value1, Long value2) {
            addCriterion("staff_id not between", value1, value2, "staffId");
            return (Criteria) this;
        }

        public Criteria andIsDeletedIsNull() {
            addCriterion("is_deleted is null");
            return (Criteria) this;
        }

        public Criteria andIsDeletedIsNotNull() {
            addCriterion("is_deleted is not null");
            return (Criteria) this;
        }

        public Criteria andIsDeletedEqualTo(Integer value) {
            addCriterion("is_deleted =", value, "isDeleted");
            return (Criteria) this;
        }

        public Criteria andIsDeletedNotEqualTo(Integer value) {
            addCriterion("is_deleted <>", value, "isDeleted");
            return (Criteria) this;
        }

        public Criteria andIsDeletedGreaterThan(Integer value) {
            addCriterion("is_deleted >", value, "isDeleted");
            return (Criteria) this;
        }

        public Criteria andIsDeletedGreaterThanOrEqualTo(Integer value) {
            addCriterion("is_deleted >=", value, "isDeleted");
            return (Criteria) this;
        }

        public Criteria andIsDeletedLessThan(Integer value) {
            addCriterion("is_deleted <", value, "isDeleted");
            return (Criteria) this;
        }

        public Criteria andIsDeletedLessThanOrEqualTo(Integer value) {
            addCriterion("is_deleted <=", value, "isDeleted");
            return (Criteria) this;
        }

        public Criteria andIsDeletedLike(Integer value) {
            addCriterion("is_deleted like", value, "isDeleted");
            return (Criteria) this;
        }

        public Criteria andIsDeletedNotLike(Integer value) {
            addCriterion("is_deleted not like", value, "isDeleted");
            return (Criteria) this;
        }

        public Criteria andIsDeletedIn(List<Integer> values) {
            addCriterion("is_deleted in", values, "isDeleted");
            return (Criteria) this;
        }

        public Criteria andIsDeletedNotIn(List<Integer> values) {
            addCriterion("is_deleted not in", values, "isDeleted");
            return (Criteria) this;
        }

        public Criteria andIsDeletedBetween(Integer value1, Integer value2) {
            addCriterion("is_deleted between", value1, value2, "isDeleted");
            return (Criteria) this;
        }

        public Criteria andIsDeletedNotBetween(Integer value1, Integer value2) {
            addCriterion("is_deleted not between", value1, value2, "isDeleted");
            return (Criteria) this;
        }

    }

    /**
     * This class corresponds to the database table pcl_insurance_info
    */
    public  static class Criteria extends GeneratedCriteria{
        protected Criteria() {
            super();
        }
    }



    @Override
    public String toString(){
        return ReflectionToStringBuilder.toString(this, ToStringStyle.DEFAULT_STYLE);
    }
}